forum

home / developersection / forums / how to bind two drop-downs from two different tables

Ask Question

How to Bind two Drop-Downs From two Different Tables

Manish Kumar 1714 12-Jun-2017

I have two dropdownlist in the page. 

how to bind these two dropdownlist from database 

One Dropdownlist has to bind from One Table and Another Dropdownlist is to bind from another table.

 

Thanks,

c# c#  mvc4 
Updated on 12-Jun-2017
Manish Kumar

Other

Message
Can you answer this question?
Answer

1 Answers

Manish Kumar

Manish Kumar

12-Jun-2017

You can use ViewModel to load two dropdownlist from multiple tables like below

Model

Create a ViewModel in your model folder


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
 
namespace Testing.Models
{
    public class MultipleTableViewModel
    {
        public IEnumerable<SelectListItem> Customerlist { get; set; }
 
        public IEnumerable<SelectListItem> Productlist { get; set; }
    }
}
 
 

 Now load the ViewModel with data in controller


   public ActionResult Index()
        {         
         
 
            AdventureWorksEntities db = new AdventureWorksEntities();
 
            //Get the Customer Details
            var Customerresult =db.Customers.Take(10).Select(c => new SelectListItem
            {
                Value = c.PersonID.ToString(),
                Text = c.StoreID.ToString()
 
            });
 
            //Get the Product Details
            var Productresult =db.Products.Take(10).Select(c => new SelectListItem
            {
                Value = c.ProductID.ToString(),
                Text = c.Name.ToString()
 
            });
 
            //Assign those resuLts to ViewModel
            var model = new MultipleTableViewModel
            {
                Customerlist = Customerresult,
                Productlist = Productresult
            };
 
            //Pass the model to View
            return View(model);
 
        }        


view code


@model  Testing.Models.MultipleTableViewModel
 
<!DOCTYPE html>
<html>
<head>
</head>
<body>
   
@using (Html.BeginForm())
   
{
       
@Html.DropDownList("Customer", new SelectList(Model.Customerlist, "Value", "Text"))
       
@Html.DropDownList("Product", new SelectList(Model.Productlist, "Value", "Text"))
   
}
</body>
</html>

 

Hope this will helps you..


advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy